// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   register_draft_ok.java

package ecommerce.website.contact;

import com.jspsmart.upload.*;
import include.nseer_cookie.*;
import include.nseer_db.nseer_db_backup1;
import java.io.IOException;
import java.net.URL;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;

public class register_draft_ok extends HttpServlet
{

	ServletContext application;
	HttpSession session;
	nseer_db_backup1 erp_db;

	public register_draft_ok()
	{
		erp_db = null;
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		String path = dbApplication.getRealPath("/");
		try
		{
			HttpSession session = request.getSession();
			counter count = new counter(dbApplication);
			java.io.PrintWriter out = response.getWriter();
			String mod = request.getRequestURI();
			SmartUpload mySmartUpload = new SmartUpload();
			mySmartUpload.setCharset("UTF-8");
			getAttachmentLength getAttachmentLength = new getAttachmentLength();
			nseer_db_backup1 ecommerce_db = new nseer_db_backup1(dbApplication);
			if (ecommerce_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				mySmartUpload.initialize(pageContext);
				String file_type = getFileLength.getFileType((String)session.getAttribute("unit_db_name"));
				long d = getFileLength.getFileLength((String)session.getAttribute("unit_db_name"));
				mySmartUpload.setMaxFileSize(d);
				mySmartUpload.setAllowedFilesList(file_type);
				try
				{
					String time = "";
					Date now = new Date();
					SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
					time = formatter.format(now);
					mySmartUpload.upload();
					String file_name[] = new String[mySmartUpload.getFiles().getCount()];
					String filekind_chain = mySmartUpload.getRequest().getParameter("filekind_chain");
					String chain_id = Divide1.getId(filekind_chain);
					String chain_name = Divide1.getName(filekind_chain);
					String sql2 = (new StringBuilder("select * from ecommerce_contact where chain_id='")).append(chain_id).append("'").toString();
					ResultSet rs2 = ecommerce_db.executeQuery(sql2);
					if (!rs2.next())
					{
						String tel = mySmartUpload.getRequest().getParameter("tel");
						String address = mySmartUpload.getRequest().getParameter("address");
						String fax = mySmartUpload.getRequest().getParameter("fax");
						String postcode = mySmartUpload.getRequest().getParameter("postcode");
						String register = mySmartUpload.getRequest().getParameter("register");
						String qq1 = mySmartUpload.getRequest().getParameter("qq1");
						String qq2 = mySmartUpload.getRequest().getParameter("qq2");
						String qq3 = mySmartUpload.getRequest().getParameter("qq3");
						String qq4 = mySmartUpload.getRequest().getParameter("qq4");
						String email = mySmartUpload.getRequest().getParameter("email");
						String register_time = mySmartUpload.getRequest().getParameter("register_time");
						for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++)
						{
							SmartFile file = mySmartUpload.getFiles().getFile(i);
							if (file.isMissing())
							{
								file_name[i] = "";
							} else
							{
								int filenum = count.read((String)dbSession.getAttribute("unit_db_name"), "ecommerceAttachmentcount");
								count.write((String)dbSession.getAttribute("unit_db_name"), "ecommerceAttachmentcount", filenum);
								file_name[i] = (new StringBuilder(String.valueOf(filenum))).append(file.getFileName()).toString();
								file.saveAs((new StringBuilder(String.valueOf(path))).append("ecommerce\\file_attachments\\").append(filenum).append(file.getFileName()).toString());
							}
						}

						try
						{
							String contact_ID = NseerId.getId(getClass().getResource("").toString(), (String)dbSession.getAttribute("unit_db_name"));
							String sqla = "insert into ecommerce_contact(contact_ID,chain_id,chain_name,address,tel,fax,postcode,register,register_time,email,qq1,qq2,qq3,qq4,check_tag";
							String sqlb = (new StringBuilder(") values ('")).append(contact_ID).append("','").append(chain_id).append("','").append(chain_name).append("','").append(address).append("','").append(tel).append("','").append(fax).append("','").append(postcode).append("','").append(register).append("','").append(register_time).append("','").append(email).append("','").append(qq1).append("','").append(qq2).append("','").append(qq3).append("','").append(qq4).append("','5'").toString();
							for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++)
							{
								int p = i + 1;
								sqla = (new StringBuilder(String.valueOf(sqla))).append(",attachment").append(p).toString();
								sqlb = (new StringBuilder(String.valueOf(sqlb))).append(",'").append(file_name[i]).append("'").toString();
							}

							String sql = (new StringBuilder(String.valueOf(sqla))).append(sqlb).append(")").toString();
							ecommerce_db.executeUpdate(sql);
							response.sendRedirect("ecommerce/website/contact/register_draft_ok.jsp?finished_tag=1");
						}
						catch (Exception ex)
						{
							ex.printStackTrace();
						}
					} else
					{
						response.sendRedirect("ecommerce/website/contact/register_draft_ok.jsp?finished_tag=2");
					}
					ecommerce_db.commit();
					ecommerce_db.close();
				}
				catch (Exception ex)
				{
					response.sendRedirect("ecommerce/website/contact/register_ok_a.jsp");
				}
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
